Sites Report

Dataset statistics

Number of variables	13
Number of observations	254312
Missing cells	25310
Missing cells (%)	0.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	27.2 MiB
Average record size in memory	112.0 B

Variable types

Numeric	11
DateTime	1
Categorical	1

Alerts

`MP1 FLOW1 (l/s)` is highly correlated with `MP1 PDEPTH_1 (mm)` and 3 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 WATERTEMP_1 (°C)` is highly correlated with `month`	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`month` is highly correlated with `MP1 WATERTEMP_1 (°C)`	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `MP1 PDEPTH_1 (mm)` and 3 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`MP1 WATERTEMP_1 (°C)` is highly correlated with `month`	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)`	High correlation
`month` is highly correlated with `MP1 WATERTEMP_1 (°C)`	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `MP1 PDEPTH_1 (mm)` and 3 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 2 other fields	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)`	High correlation
`Daily Cumulative Rainfall (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 4 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 WATERTEMP_1 (°C)` is highly correlated with `month`	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)` and 1 other fields	High correlation
`month` is highly correlated with `MP1 WATERTEMP_1 (°C)`	High correlation
`targets` is highly correlated with `Raw Average Velocity (m/s)`	High correlation
`MP1 FLOW1 (l/s)` has 4213 (1.7%) missing values	Missing
`MP1 PDEPTH_1 (mm)` has 4213 (1.7%) missing values	Missing
`MP1 UNIDEPTH (mm)` has 4213 (1.7%) missing values	Missing
`MP1 UpDEPTH_1 (mm)` has 4213 (1.7%) missing values	Missing
`MP1 WATERTEMP_1 (°C)` has 4213 (1.7%) missing values	Missing
`Raw Average Velocity (m/s)` has 4213 (1.7%) missing values	Missing
`Final Rainfall (mm)` is highly skewed (γ1 = 42.53877637)	Skewed
`MP1 PDEPTH_1 (mm)` is highly skewed (γ1 = 38.566953)	Skewed
`MP1 UNIDEPTH (mm)` is highly skewed (γ1 = 39.01797907)	Skewed
`date` has unique values	Unique
`Daily Cumulative Rainfall (mm)` has 176634 (69.5%) zeros	Zeros
`Final Rainfall (mm)` has 246640 (97.0%) zeros	Zeros
`MP1 FLOW1 (l/s)` has 4243 (1.7%) zeros	Zeros
`Raw Average Velocity (m/s)` has 4243 (1.7%) zeros	Zeros
`hour` has 10597 (4.2%) zeros	Zeros

Reproduction

Analysis started	2021-12-13 10:15:18.559260
Analysis finished	2021-12-13 10:15:42.133796
Duration	23.57 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Daily Cumulative Rainfall (mm)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	447
Distinct (%)	0.2%
Missing	16
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.064516157

Minimum	0
Maximum	68.5
Zeros	176634
Zeros (%)	69.5%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.2
95-th percentile	6.6
Maximum	68.5
Range	68.5
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	3.505419053
Coefficient of variation (CV)	3.292969328
Kurtosis	65.65429192
Mean	1.064516157
Median Absolute Deviation (MAD)	0
Skewness	6.553403856
Sum	270702.2005
Variance	12.28796273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	176634	69.5%
0.2	11024	4.3%
0.1	5860	2.3%
0.4	4825	1.9%
0.3	3901	1.5%
0.6	3176	1.2%
0.5	2792	1.1%
1.6	1939	0.8%
1.2	1710	0.7%
0.8	1640	0.6%
Other values (437)	40795	16.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	176634	69.5%
0.1	5860	2.3%
0.2	11024	4.3%
0.3	3901	1.5%
0.4	4825	1.9%
0.5	2792	1.1%
0.6	3176	1.2%
0.7	846	0.3%
0.8	1640	0.6%
0.9	755	0.3%

Value	Count	Frequency (%)
68.5	1	< 0.1%
68.3	1	< 0.1%
68.1	1	< 0.1%
67.9	1	< 0.1%
67.8	1	< 0.1%
67.6	1	< 0.1%
67.4	1	< 0.1%
67.3	1	< 0.1%
67.2	1	< 0.1%
67.1	1	< 0.1%

Final Rainfall (mm)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	48
Distinct (%)	< 0.1%
Missing	16
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.007212461069

Minimum	0
Maximum	9.4
Zeros	246640
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	9.4
Range	9.4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.08117148965
Coefficient of variation (CV)	11.25434008
Kurtosis	2825.097805
Mean	0.007212461069
Median Absolute Deviation (MAD)	0
Skewness	42.53877637
Sum	1834.1
Variance	0.006588810732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0	246640	97.0%
0.1	3560	1.4%
0.2	2684	1.1%
0.4	588	0.2%
0.3	318	0.1%
0.6	166	0.1%
0.5	62	< 0.1%
0.8	61	< 0.1%
1	42	< 0.1%
1.2	24	< 0.1%
Other values (38)	151	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	246640	97.0%
0.1	3560	1.4%
0.2	2684	1.1%
0.3	318	0.1%
0.4	588	0.2%
0.5	62	< 0.1%
0.6	166	0.1%
0.7	18	< 0.1%
0.8	61	< 0.1%
0.9	10	< 0.1%

Value	Count	Frequency (%)
9.4	1	< 0.1%
7.2	2	< 0.1%
7.1	1	< 0.1%
6.2	1	< 0.1%
5.8	1	< 0.1%
5.6	2	< 0.1%
5.4	1	< 0.1%
5.2	1	< 0.1%
5	2	< 0.1%
4.8	4	< 0.1%

MP1 FLOW1 (l/s)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	241368
Distinct (%)	96.5%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	5.006886341

Minimum	0
Maximum	66.66148
Zeros	4243
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1.5910277
Q1	3.30221
median	4.912778
Q3	6.24276
95-th percentile	8.8093148
Maximum	66.66148
Range	66.66148
Interquartile range (IQR)	2.94055

Descriptive statistics

Standard deviation	2.776194198
Coefficient of variation (CV)	0.5544751786
Kurtosis	64.78056525
Mean	5.006886341
Median Absolute Deviation (MAD)	1.456098
Skewness	4.536605925
Sum	1252217.267
Variance	7.707254225
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4243	1.7%
5.285726	4	< 0.1%
4.271876	3	< 0.1%
5.013578	3	< 0.1%
6.631992	3	< 0.1%
6.065001	3	< 0.1%
3.238915	3	< 0.1%
3.484128	3	< 0.1%
4.678753	3	< 0.1%
5.688532	3	< 0.1%
Other values (241358)	245828	96.7%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4243	1.7%
0.122645	1	< 0.1%
0.143324	1	< 0.1%
0.208879	1	< 0.1%
0.246496	1	< 0.1%
0.330284	1	< 0.1%
0.357559	1	< 0.1%
0.363016	1	< 0.1%
0.415321	1	< 0.1%
0.41898	1	< 0.1%

Value	Count	Frequency (%)
66.66148	1	< 0.1%
66.61517	1	< 0.1%
65.48769	1	< 0.1%
65.31937	1	< 0.1%
64.44538	1	< 0.1%
64.30639	1	< 0.1%
64.23135	1	< 0.1%
64.13335	1	< 0.1%
64.05045	1	< 0.1%
64.03623	1	< 0.1%

MP1 PDEPTH_1 (mm)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	9727
Distinct (%)	3.9%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	60.65428626

Minimum	0
Maximum	2604.37
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	40.37
Q1	52.19
median	59.47
Q3	66.6
95-th percentile	80.68
Maximum	2604.37
Range	2604.37
Interquartile range (IQR)	14.41

Descriptive statistics

Standard deviation	46.62398603
Coefficient of variation (CV)	0.7686841096
Kurtosis	1719.003472
Mean	60.65428626
Median Absolute Deviation (MAD)	7.2
Skewness	38.566953
Sum	15169576.34
Variance	2173.796073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.73	137	0.1%
58.74	128	0.1%
61.26	127	< 0.1%
58.56	126	< 0.1%
58.97	122	< 0.1%
58.36	122	< 0.1%
57.94	122	< 0.1%
57.83	121	< 0.1%
60.8	121	< 0.1%
59.84	120	< 0.1%
Other values (9717)	248853	97.9%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
5.71	1	< 0.1%
5.89	1	< 0.1%
5.92	1	< 0.1%
6.15	1	< 0.1%
6.45	1	< 0.1%
6.46	1	< 0.1%
6.53	2	< 0.1%
6.57	1	< 0.1%
6.74	2	< 0.1%

Value	Count	Frequency (%)
2604.37	1	< 0.1%
2597.59	1	< 0.1%
2584.69	1	< 0.1%
2570.91	1	< 0.1%
2568.81	1	< 0.1%
2552.14	1	< 0.1%
2551.7	1	< 0.1%
2535.91	1	< 0.1%
2500.16	1	< 0.1%
2481.31	1	< 0.1%

MP1 UNIDEPTH (mm)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	8083
Distinct (%)	3.2%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	61.01146074

Minimum	-253.75
Maximum	2604.37
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	3.9 MiB

Quantile statistics

Minimum	-253.75
5-th percentile	40.44
Q1	52.06
median	60.29
Q3	66.83
95-th percentile	79.66
Maximum	2604.37
Range	2858.12
Interquartile range (IQR)	14.77

Descriptive statistics

Standard deviation	46.43689921
Coefficient of variation (CV)	0.7611176432
Kurtosis	1745.716519
Mean	61.01146074
Median Absolute Deviation (MAD)	7.32
Skewness	39.01797907
Sum	15258905.32
Variance	2156.385608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.36	126	< 0.1%
62.35	126	< 0.1%
62.24	125	< 0.1%
61.74	125	< 0.1%
61.96	124	< 0.1%
61.8	124	< 0.1%
61.98	124	< 0.1%
63.75	124	< 0.1%
64.02	124	< 0.1%
62.27	124	< 0.1%
Other values (8073)	248853	97.9%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-253.75	1	< 0.1%
12.16	1	< 0.1%
12.45	1	< 0.1%
12.68	1	< 0.1%
12.86	1	< 0.1%
12.91	1	< 0.1%
12.95	1	< 0.1%
13.02	1	< 0.1%
13.11	1	< 0.1%
13.27	1	< 0.1%

Value	Count	Frequency (%)
2604.37	1	< 0.1%
2597.59	1	< 0.1%
2584.69	1	< 0.1%
2570.91	1	< 0.1%
2568.81	1	< 0.1%
2552.14	1	< 0.1%
2551.7	1	< 0.1%
2535.91	1	< 0.1%
2500.16	1	< 0.1%
2481.31	1	< 0.1%

MP1 UpDEPTH_1 (mm)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	8004
Distinct (%)	3.2%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	60.15066026

Minimum	-253.75
Maximum	435.06
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	3.9 MiB

Quantile statistics

Minimum	-253.75
5-th percentile	40.45
Q1	52.06
median	60.29
Q3	66.83
95-th percentile	79.66
Maximum	435.06
Range	688.81
Interquartile range (IQR)	14.77

Descriptive statistics

Standard deviation	15.97931283
Coefficient of variation (CV)	0.2656548201
Kurtosis	228.5955856
Mean	60.15066026
Median Absolute Deviation (MAD)	7.32
Skewness	9.985162944
Sum	15043619.98
Variance	255.3384385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.36	126	< 0.1%
62.35	126	< 0.1%
61.74	125	< 0.1%
62.24	125	< 0.1%
61.96	124	< 0.1%
61.8	124	< 0.1%
62.27	124	< 0.1%
64.02	124	< 0.1%
63.75	124	< 0.1%
61.98	124	< 0.1%
Other values (7994)	248853	97.9%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-253.75	1	< 0.1%
25.81	1	< 0.1%
25.88	1	< 0.1%
25.94	1	< 0.1%
26	1	< 0.1%
26.06	1	< 0.1%
26.09	1	< 0.1%
26.16	1	< 0.1%
26.64	1	< 0.1%
26.74	1	< 0.1%

Value	Count	Frequency (%)
435.06	1	< 0.1%
434.95	1	< 0.1%
434.77	1	< 0.1%
434.37	1	< 0.1%
434.27	1	< 0.1%
434.2	1	< 0.1%
434.19	1	< 0.1%
434.14	2	< 0.1%
434.13	1	< 0.1%
434.11	2	< 0.1%

MP1 WATERTEMP_1 (°C)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	142
Distinct (%)	0.1%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	16.29478966

Minimum	-17.8
Maximum	23.3
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	3.9 MiB

Quantile statistics

Minimum	-17.8
5-th percentile	12.1
Q1	14.1
median	15.9
Q3	18.7
95-th percentile	20.9
Maximum	23.3
Range	41.1
Interquartile range (IQR)	4.6

Descriptive statistics

Standard deviation	2.762145857
Coefficient of variation (CV)	0.1695109857
Kurtosis	-0.9221257188
Mean	16.29478966
Median Absolute Deviation (MAD)	2.2
Skewness	0.1881975
Sum	4075310.6
Variance	7.629449737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.8	4655	1.8%
14.3	4581	1.8%
14.6	4553	1.8%
15.3	4370	1.7%
15.1	4194	1.6%
13.8	4183	1.6%
14.1	4157	1.6%
14.5	3850	1.5%
15	3797	1.5%
15.6	3650	1.4%
Other values (132)	208109	81.8%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-17.8	1	< 0.1%
8.9	3	< 0.1%
9	1	< 0.1%
9.1	3	< 0.1%
9.5	6	< 0.1%
9.6	4	< 0.1%
9.7	3	< 0.1%
9.8	4	< 0.1%
10	8	< 0.1%
10.1	15	< 0.1%

Value	Count	Frequency (%)
23.3	3	< 0.1%
23.2	3	< 0.1%
23.1	8	< 0.1%
23	8	< 0.1%
22.9	24	< 0.1%
22.8	20	< 0.1%
22.7	39	< 0.1%
22.6	37	< 0.1%
22.5	46	< 0.1%
22.4	69	< 0.1%

Raw Average Velocity (m/s)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	895
Distinct (%)	0.4%
Missing	4213
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.3843306742

Minimum	0
Maximum	0.9531
Zeros	4243
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0.189
Q1	0.3249
median	0.4041
Q3	0.4563
95-th percentile	0.522
Maximum	0.9531
Range	0.9531
Interquartile range (IQR)	0.1314

Descriptive statistics

Standard deviation	0.1091561765
Coefficient of variation (CV)	0.284016301
Kurtosis	1.736174111
Mean	0.3843306742
Median Absolute Deviation (MAD)	0.063
Skewness	-0.8131069782
Sum	96120.7173
Variance	0.01191507086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4243	1.7%
0.4383	1261	0.5%
0.432	1246	0.5%
0.4374	1228	0.5%
0.4392	1213	0.5%
0.4365	1206	0.5%
0.4347	1195	0.5%
0.4356	1194	0.5%
0.4302	1185	0.5%
0.4338	1184	0.5%
Other values (885)	234944	92.4%
(Missing)	4213	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4243	1.7%
0.0144	1	< 0.1%
0.018	1	< 0.1%
0.0261	1	< 0.1%
0.027	1	< 0.1%
0.0288	1	< 0.1%
0.0306	2	< 0.1%
0.0342	1	< 0.1%
0.0432	1	< 0.1%
0.0441	1	< 0.1%

Value	Count	Frequency (%)
0.9531	1	< 0.1%
0.8946	1	< 0.1%
0.8901	1	< 0.1%
0.8829	1	< 0.1%
0.882	1	< 0.1%
0.8775	1	< 0.1%
0.8757	1	< 0.1%
0.8748	1	< 0.1%
0.8739	1	< 0.1%
0.8712	2	< 0.1%

hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.49995281

Minimum	0
Maximum	23
Zeros	10597
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12.25

Descriptive statistics

Standard deviation	6.922248068
Coefficient of variation (CV)	0.6019370844
Kurtosis	-1.204177677
Mean	11.49995281
Median Absolute Deviation (MAD)	6
Skewness	2.599801282 × 10^-5
Sum	2924576
Variance	47.91751831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
23	10598	4.2%
4	10598	4.2%
8	10597	4.2%
6	10597	4.2%
0	10597	4.2%
12	10597	4.2%
15	10596	4.2%
22	10596	4.2%
21	10596	4.2%
20	10596	4.2%
Other values (14)	148344	58.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10597	4.2%
1	10596	4.2%
2	10596	4.2%
3	10596	4.2%
4	10598	4.2%
5	10596	4.2%
6	10597	4.2%
7	10596	4.2%
8	10597	4.2%
9	10596	4.2%

Value	Count	Frequency (%)
23	10598	4.2%
22	10596	4.2%
21	10596	4.2%
20	10596	4.2%
19	10596	4.2%
18	10596	4.2%
17	10596	4.2%
16	10596	4.2%
15	10596	4.2%
14	10596	4.2%

day
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.73617446

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.805063711
Coefficient of variation (CV)	0.5595428375
Kurtosis	-1.193283463
Mean	15.73617446
Median Absolute Deviation (MAD)	8
Skewness	0.007382156183
Sum	4001898
Variance	77.52914695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
19	8354	3.3%
14	8353	3.3%
5	8353	3.3%
22	8353	3.3%
1	8353	3.3%
28	8353	3.3%
6	8352	3.3%
18	8352	3.3%
27	8352	3.3%
26	8352	3.3%
Other values (21)	170785	67.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8353	3.3%
2	8352	3.3%
3	8352	3.3%
4	8352	3.3%
5	8353	3.3%
6	8352	3.3%
7	8352	3.3%
8	8352	3.3%
9	8352	3.3%
10	8352	3.3%

Value	Count	Frequency (%)
31	5184	2.0%
30	7489	2.9%
29	7776	3.1%
28	8353	3.3%
27	8352	3.3%
26	8352	3.3%
25	8352	3.3%
24	8352	3.3%
23	8352	3.3%
22	8353	3.3%

month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.926397496

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.461526366
Coefficient of variation (CV)	0.5840860942
Kurtosis	-1.167999473
Mean	5.926397496
Median Absolute Deviation (MAD)	3
Skewness	0.2512528015
Sum	1507154
Variance	11.98216478
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	26785	10.5%
1	26784	10.5%
3	26784	10.5%
4	25921	10.2%
2	24482	9.6%
12	18144	7.1%
10	17858	7.0%
7	17856	7.0%
8	17856	7.0%
6	17281	6.8%
Other values (2)	34561	13.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	26784	10.5%
2	24482	9.6%
3	26784	10.5%
4	25921	10.2%
5	26785	10.5%
6	17281	6.8%
7	17856	7.0%
8	17856	7.0%
9	17280	6.8%
10	17858	7.0%

Value	Count	Frequency (%)
12	18144	7.1%
11	17281	6.8%
10	17858	7.0%
9	17280	6.8%
8	17856	7.0%
7	17856	7.0%
6	17281	6.8%
5	26785	10.5%
4	25921	10.2%
3	26784	10.5%

date
Date

UNIQUE

Distinct	254312
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Minimum	2018-12-31 00:00:00
Maximum	2021-06-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

targets
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.0 MiB

0	230080
1	24232

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	230080	90.5%
1	24232	9.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	230080	90.5%
1	24232	9.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	MP1 FLOW1 (l/s)	MP1 PDEPTH_1 (mm)	MP1 UNIDEPTH (mm)	MP1 UpDEPTH_1 (mm)	MP1 WATERTEMP_1 (°C)	Raw Average Velocity (m/s)	day	month	date
0	2.744015	50.96	64.10	64.10	15.2	0.1962	31	12	2018-12-31 00:00:00
1	2.709665	63.41	64.85	64.85	15.1	0.1908	31	12	2018-12-31 00:05:00
2	2.720578	64.29	63.58	63.58	15.1	0.1971	31	12	2018-12-31 00:10:00
3	2.394623	64.10	58.52	58.52	15.1	0.1962	31	12	2018-12-31 00:15:00
4	2.316329	63.89	57.02	57.02	15.0	0.1971	31	12	2018-12-31 00:20:00
5	1.701397	63.73	45.51	45.51	14.9	0.1998	31	12	2018-12-31 00:25:00
6	2.268245	63.68	56.34	56.34	15.0	0.1962	31	12	2018-12-31 00:30:00
7	2.572402	63.84	59.65	59.65	15.0	0.2043	31	12	2018-12-31 00:35:00
8	2.528456	63.72	58.98	58.98	14.8	0.2043	31	12	2018-12-31 00:40:00
9	2.210480	62.90	57.50	57.50	14.8	0.1854	31	12	2018-12-31 00:45:00

Last rows

	MP1 FLOW1 (l/s)	MP1 PDEPTH_1 (mm)	MP1 UNIDEPTH (mm)	MP1 UpDEPTH_1 (mm)	MP1 WATERTEMP_1 (°C)	Raw Average Velocity (m/s)	hour	day	month	date	targets
254302	0.00000	83.83	79.50	79.50	15.4	0.0000	23	31	5	2021-05-31 23:15:00	1
254303	4.31069	85.13	79.43	79.43	15.3	0.2430	23	31	5	2021-05-31 23:20:00	1
254304	0.00000	85.36	79.35	79.35	15.4	0.0000	23	31	5	2021-05-31 23:25:00	1
254305	0.00000	84.30	79.19	79.19	15.4	0.0000	23	31	5	2021-05-31 23:30:00	1
254306	0.00000	83.82	79.07	79.07	15.3	0.0000	23	31	5	2021-05-31 23:35:00	1
254307	0.00000	83.92	78.88	78.88	15.3	0.0000	23	31	5	2021-05-31 23:40:00	1
254308	0.00000	83.66	78.70	78.70	15.3	0.0000	23	31	5	2021-05-31 23:45:00	1
254309	3.96669	83.75	78.65	78.65	15.3	0.2268	23	31	5	2021-05-31 23:50:00	1
254310	0.00000	83.90	78.54	78.54	15.3	0.0000	23	31	5	2021-05-31 23:55:00	1
254311	0.00000	82.96	78.44	78.44	15.2	0.0000	0	1	6	2021-06-01 00:00:00	1

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows